ICDLineItemReference

Entity Definition

Logical Name : ICDLineItemReference
Physical Name : CO_RFC_LTM_ICD

A record of a relationship between two line items in an InventoryControlDocument, or between two line items in two different InventoryControlDocuments.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer ICDLineItem(DO_LTM_ICD)
InventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint ICDLineItem(DO_LTM_ICD)
RefersToInventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD_TO Identity integer ICDLineItem(DO_LTM_ICD)
RefersToInventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD_TO LineNumber smallint ICDLineItem(DO_LTM_ICD)

Relationships

Parent Entity Verb Phrase Child Entity
ICDLineItem is referred to ICDLineItemReference
ICDLineItem refers to ICDLineItemReference

Logical Views containing ICDLineItemReference

Logical View
Logical 02100 - Item Inventory - Macro View
Logical 02120 - Item Inventory - Order View
Logical 02130 - Item Inventory - Receiving View
Logical 02316 - Distributed Order Management View